﻿CREATE PROCEDURE [dbo].[ClearTransaction]
	@TranId int
AS
BEGIN
	BEGIN TRANSACTION T1
		DELETE TransactionCredits WHERE TransactionId = @TranId;
		DELETE TransactionDebits WHERE TransactionId = @TranId;
	COMMIT TRANSACTION T1;
END